After an execution plan is generated , it stays in the procedure cache 生成执行计划后,它处于过程缓存中。
Number of pages in the procedure cache that are currently allocated to this process 当前为此进程分配的过程缓存中的页数。
The lazywriter process periodically scans the list of objects in the procedure cache 惰性写入器进程定期扫描过程缓存中的对象列表。
The part of the memory pool that is used to store execution plans is referred to as the procedure cache 内存池中用于存储执行计划的部分称为过程缓存。
The age of our sample query plan is decremented to 0 after 16 scans of the procedure cache , unless another user references the plan 在本例中,查询计划的年经过16次过程缓存扫描后减为0 ,除非其他用户引用了该计划。